DETALLESALIDA

"192.168.0.1:sipop"

DETALLESALIDA

Descriptions

DETALLE DE SALIDA DE MATERIALES EN BODEGA

Fields

Name	Data type	Description
REGISTRO_SALIDA	CHAR (8)	ID del registro maestro
ARTICULO	CHAR (8)	ID del producto
CANTIDAD	FLOAT	Cantidad que se retira
COSTO_PROMEDIO	FLOAT	Costo promedio del producto, se calcula
COD_INGRESO	CHAR (8)	Codigo del detalle ingreso de donde se retira el producto

Triggers

Trigger	Type	Active	Position	Description
AI_UPDATEEXISTENCIA	After Insert		0

Indices

There are no indices for table DETALLESALIDA

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
INVENTARIO	INTEG_253	ARTICULO	ID_ARTICULO	RESTRICT	RESTRICT
REGISTROSALIDA	INTEG_254	REGISTRO_SALIDA	ID_REGISTRO_SALIDAD	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table DETALLESALIDA

Definition


CREATE TABLE DETALLESALIDA (
    REGISTRO_SALIDA CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ARTICULO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    CANTIDAD FLOAT NOT NULL,
    COSTO_PROMEDIO FLOAT,
    COD_INGRESO CHAR (8) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE DETALLESALIDA ADD  FOREIGN KEY (ARTICULO) REFERENCES INVENTARIO (ID_ARTICULO);
ALTER TABLE DETALLESALIDA ADD  FOREIGN KEY (REGISTRO_SALIDA) REFERENCES REGISTROSALIDA (ID_REGISTRO_SALIDAD);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.